Count by Member Type spreadsheet report

From Customers, select Generate reports > Statistics > Spread/Graph - Count By Member Type